<!DOCTYPE html>
<html lang="en">

<head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
    <meta charset="utf-8"/>
    <title></title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1, user-scalable=no"/>
    <meta name="description" content=""/>
    <meta name="author" content=""/>
    <!-- STYLESHEETS -->
    <!--[if lt IE 9]>
    <script src="../../js/flot/excanvas.min.js"></script>
    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    <script src="http://css3-mediaqueries-js.googlecode.com/svn/trunk/css3-mediaqueries.js"></script><![endif]-->
    <link rel="stylesheet" type="text/css" href="../../css/cloud-admin.css"/>
    <link rel="stylesheet" type="text/css" href="../../css/themes/default.css" id="skin-switcher"/>
    <link rel="stylesheet" type="text/css" href="../../css/responsive.css"/>
    <link href="../../font-awesome/css/font-awesome.min.css" rel="stylesheet"/>
    <!-- SELECT2 -->
    <link rel="stylesheet" type="text/css" href="../../js/select2/select2.min.css"/>
    <!-- UNIFORM -->
    <link rel="stylesheet" type="text/css" href="../../js/uniform/css/uniform.default.min.css"/>
    <!-- datatable -->
    <link rel="stylesheet" href="../../js/datatables/datatable.css"/>
    <link rel="stylesheet" href="../../js/datepicker/datepicker.css"/>
    <style>
        .dataTables_scrollBody table td,
        .dataTables_scrollHeadInner table th {
            text-align: center;
        }
    </style>
</head>

<body>
<header class="navbar clearfix" id="header">
</header>
<!-- PAGE -->
<section id="page">
    <!-- SIDEBAR -->
    <div id="sidebar" class="sidebar">
        <div class="sidebar-menu nav-collapse">
            <!-- SIDEBAR MENU -->
            <ul>
            </ul>
        </div>
    </div>
    <!-- /SIDEBAR -->
    <div id="main-content">
        <div class="container">
            <div class="row">
                <div id="content" class="col-lg-12">
                    <!-- PAGE HEADER-->
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="page-header">
                                <!-- STYLER -->
                                <!-- /STYLER -->
                                <!-- BREADCRUMBS -->
                                <ul class="breadcrumb">
                                    <li><i class="fa fa-home"></i> <a href="index.html">首页</a></li>
                                    <li><a href="#">营销管理</a></li>
                                    <li>优惠劵</li>
                                </ul>
                                <!-- /BREADCRUMBS -->
                            </div>
                        </div>
                    </div>
                    <!-- /PAGE HEADER -->
                    <!-- 数据统计 start -->
                    <!-- <div class="row">
          <div class="col-md-12">
           <div class="row">
            <div class="col-md-12">
             <div class="box border primary">
              <div class="box-title">
               <h4> <i class="fa fa-bars"></i> 查询条件 </h4>
              </div>
              <div class="box-body big data-sta-top">
               <form class="form-horizontal">
                <div class="form-group mrg-bt10">
                  <label class="col-sm-1 control-label" style="width: auto;line-height: 34px;vertical-align: middle;">时间：</label>
                  <a href="javascript:;" class="btn btn-info data-sta-btn">今天</a>
                  <a href="javascript:;" class="btn btn-success data-sta-btn">昨天</a>
                  <a href="javascript:;" class="btn btn-warning data-sta-btn">最近7天</a>
                  <div class="col-md-3">
                    <input class="form-control" type="text" placeholder="Default input" style="display: inline-block" name="data-dates">
                  </div>
                </div>
               </form>
              </div>
             </div>
            </div>
           </div>
          </div>
         </div> -->
                    <!-- 数据统计 end -->
                    <!-- FORMS QUERY-->
                    <div class="row">
                        <div class="col-md-12">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="box border primary">
                                        <div class="box-title">
                                            <h4><i class="fa fa-bars"></i> 查询条件 </h4>
                                        </div>
                                        <div class="box-body">
                                            <form class="form-horizontal" role="form" id="form_Order">
                                                <div class="row">
                                                    <label class="col-sm-1 control-label" style="line-height: 34px;vertical-align: middle;">店铺名称：</label>
                                                    <div class="col-sm-2">
                                                        <select id="shopName" class="col-md-12" tabindex="-1" name="shopName">
                                                        </select>
                                                    </div>
                                                    <label class="col-sm-1 control-label" style="line-height: 34px;vertical-align: middle;">发货仓库：</label>
                                                    <div class="col-sm-2">
                                                        <select id="warehouseNo" class="col-md-12" tabindex="-1" name="warehouseNo">
                                                            <option value="0">请选择</option>
                                                            <!--<option value="All">所有仓库</option>-->
                                                            <option value="001">科捷仓</option>
                                                            <option value="009">七格格仓</option>
                                                        </select>
                                                    </div>
                                                    <label class="col-sm-1 control-label" style="line-height: 34px;vertical-align: middle;">日期区间：</label>
                                                    <div class="col-sm-4" style="display: inline-flex;width:290px">
                                                        <div class="float-left" style="width: 130px">
                                                            <input type="text" name="startDate" class="form-control bootstrap-datepicker"/>
                                                        </div>
                                                        <div style="width: 30px;line-height: 34px;text-align: center;">至</div>
                                                        <div class="float-left" style="width: 130px">
                                                            <input type="text" name="endDate" class="form-control bootstrap-datepicker"/>
                                                        </div>
                                                    </div>

                                                    <div class="col-sm-1">
                                                        <a class="btn btn-primary search">查询</a>
                                                    </div>
                                                    <div class="col-sm-1" id="resetData" hidden="true">
                                                        <a class="btn btn-primary reset">重置数据</a>
                                                    </div>
                                                </div>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!-- /FORMS QUERY -->
                    <div class="row">
                        <!-- TABLES -->
                        <div class="col-md-12">
                            <!-- BOX -->
                            <div class="box border primary">
                                <div class="box-title">
                                    <h4><i class="fa fa-table"></i> 订单金额： <span id="totalPrice"></span> 元 </h4>
                                </div>
                                <div class="box-body">
                                    <table id="db_report_list" cellpadding="0" cellspacing="0" border="0"
                                           class="datatable table table-striped table-bordered table-hover">
                                    </table>
                                </div>
                            </div>
                            <!-- /BOX -->
                        </div>
                    </div>
                    <!-- /TABLES -->
                    <div class="footer-tools">
                        <span class="go-top"> <i class="fa fa-chevron-up"></i> Top </span>
                    </div>
                </div>
                <!-- /CONTENT-->
            </div>
        </div>
    </div>
</section>
<!--/PAGE -->
<!-- JAVASCRIPTS -->
<!-- Placed at the end of the document so the pages load faster -->
<!-- JQUERY -->
<script src="../../js/jquery/jquery-2.0.3.min.js"></script>
<!-- spinner -->
<script src="../../js/spinner/spin.js"></script>
<!-- BOOTSTRAP -->
<script src="../../bootstrap-dist/js/bootstrap.min.js"></script>
<script type="text/javascript" src="../../js/bootbox/bootbox.min.js"></script>
<!-- BLOCK UI -->
<script type="text/javascript" src="../../js/jQuery-BlockUI/jquery.blockUI.min.js"></script>
<!-- AUTOSIZE -->
<script type="text/javascript" src="../../js/autosize/jquery.autosize.min.js"></script>
<!-- DATA TABLES -->
<script type="text/javascript" src="../../js/datatables/bootstrap-select.js"></script>
<script type="text/javascript" src="../../js/datatables/datatable.js"></script>
<script type="text/javascript" src="../../js/datatables/datatable-bootstrap.js"></script>
<script type="text/javascript" src="../../js/datatables/datatable-tabletools.js"></script>
<script type="text/javascript" src="../../js/datatables/fnAddTr.js"></script>
<script type="text/javascript" src="../../js/datepicker/datepicker.js"></script>
<!-- SELECT2 -->
<script type="text/javascript" src="../../js/select2/select2.min.js"></script>
<!-- UNIFORM -->
<script type="text/javascript" src="../../js/uniform/jquery.uniform.min.js"></script>
<!-- COOKIE -->
<script type="text/javascript" src="../../js/jQuery-Cookie/jquery.cookie.min.js"></script>
<!-- CUSTOM SCRIPT -->
<script src="../../js/script.js"></script>
<script src="../../js/common.js"></script>
<script>
    var Report = function () {
        var $mainDataTable = null;
        var searchData = function () {
            var startDate = $("input[name=startDate]").val();
            var endDate = $("input[name=endDate]").val();
            var shopName = $("#shopName").val();
            var warehouseNo = $("#warehouseNo").val();
            var url = App.getContextPath() + "admin/report/searchOrderReport.do?";
            if (startDate != "")
                url += "&startDate=" + startDate;
            if (endDate != "")
                url += "&endDate=" + endDate;
            if (shopName) {
                url += "&shopNo=" + shopName;
            }
            url += "&warehouseNo=" + warehouseNo;
            url += "&iDisplayLength=" + 10000;
            $.ajax({
                type: "GET",
                url: url,
                async: true,
                success: function (result) {
                    $("#totalPrice").text(format_thousands(result.sEcho))
                    createList(result.data)
                }
            });
        };
        var createList = function (data) {
            var dtSetting = $.dataTableSetting({
                "bFilter": false, // 去掉搜索框
                "bLengthChange": true, // 每页显示数量
                "sScrollX": "100%",
                "sScrollXInner": "100%",
                "iDisplayLength": 25,
                "data": data,
                "bSort": false,
                "aoColumns": [{
                    "mDataProp": "orderDate",
                    "sTitle": "日期",
                    "width": "8%",
                    "render": function (data, type, row) {
                        return new Date(row.orderDate).format("yyyy-MM-dd");
                    }
                },
                    {
                        "mDataProp": "shopName",
                        "sTitle": "店铺名称",
                        "width": "15%",
                    },
                    {
                        "mDataProp": "totalOrderCount",
                        "sTitle": "总订单数",
                        "width": "5%",
                        "class": "format_number"
                    }, {
                        "mDataProp": "totalOrderPrice",
                        "sTitle": "总订单金额",
                        "width": "10%",
                        "class": "format_thousands"
                    }, {
                        "sTitle": "总下单用户数",
                        "mDataProp": "totalUserCount",
                        "width": "8%",
                        "class": "format_number"
                    }, {
                        "sTitle": "支付订单数",
                        "mDataProp": "payOrderCount",
                        "width": "8%",
                        "class": "format_number"
                    }, {
                        "sTitle": "支付订单金额",
                        "mDataProp": "payOrderPrice",
                        "width": "10%",
                        "class": "format_thousands"
                    }, {
                        "sTitle": "支付用户数",
                        "mDataProp": "payUserCount",
                        "width": "8%",
                        "class": "format_number"
                    }, {
                        "sTitle": "总成本",
                        "mDataProp": "totalCostPrice",
                        "width": "10%",
                        "class": "format_number"
                    }, {
                        "sTitle": "毛利率",
                        "mDataProp": "grossMargin",
                        "width": "8%",
                        "class": "format_number",
                        "render": function (data, type, row) {
                            return format_thousands((row.payOrderPrice - row.totalCostPrice) / (row.payOrderPrice ==
                            0 ? 1 : row.payOrderPrice) * 100) + "%";
                        }
                    }, {
                        "sTitle": "仓库",
                        "mDataProp": "warehouseNo",
                        "width": "10%",
                        "render": function (data, type, row) {
                            var name = "未知仓库";
                            if (row.warehouseNo === "0") {
                                name = "全部仓库";
                            } else if (row.warehouseNo === "001") {
                                name = "科捷仓";
                            } else if (row.warehouseNo === "009") {
                                name = "七格格仓";
                            }
                            return name;
                        }
                    }
                ]
            });
            $mainDataTable = $("#db_report_list").dataTable(dtSetting);
        }
        var exportOrder = function () {
            var strdiv = '<form id=export action=' + App.getContextPath() +
                'admin/order/exportOrder.do><input type=hidden name=startDate value=' + $("[name=startDate]").val() +
                '><input type=hidden name=endDate value=' + $("[name=endDate]").val() + '></form>';
            $("body").append(strdiv);
            $("#export").submit();
        };
        var getWholesaler = function () {
            $.ajax({
                type: "get",
                url: App.getContextPath() + "admin/report/getAllWdtShop.do",
                data: {},
                async: true,
                success: function (result) {
                    var data = result.extra
                    var str = ''
                    str += "<option value=''>" + '全部' + "</option>"
                    for (let index = 0, length = data.length; index < length; index++) {
                        const element = data[index];
                        str += "<option value=" + element.shopNo + ">" + element.shopName + "</option>"
                    }
                    $("#shopName").append(str)
                    $("#shopName").select2();
                    searchData();
                }
            });
        }
        var resetData = function () {
            var startDate = $("input[name=startDate]").val();
            var endDate = $("input[name=endDate]").val();
            var shopName = $("#shopName").val();
            if (startDate == "" || endDate == "") {
                $.alert("请选择日期");
                return;
            }
            if (shopName == "") {
                $.alert("请选择店铺");
                return;
            }
            if (shopName === "002") {
                shopName = "M000";
            }
            $.ajax({
                type: "get",
                url: App.getContextPath() + "admin/report/resetBiOrderDay.do?shopNo=" + shopName + "&startDate=" + startDate + "&endDate=" + endDate,
                data: {},
                async: true,
                success: function (result) {
                    if (result.type = "success") {
                        $.alert("重置成功");
                        searchData();
                    } else {
                        $.alert(result.content);
                    }
                }
            });
        }
        return {
            init: function () {
                getWholesaler();
                var date = new Date().getDate() - 1
                if (!date) {
                    var curDate = new Date();
                    var curMonth = curDate.getMonth();
                    curDate.setMonth(curMonth);
                    curDate.setDate(0);
                    date = curDate.getDate()
                }
                $.initDate($("#form_Order"), -date, -1);
                $(".search").click(searchData);
                $(".reset").click(resetData);
            }
        }
    }
    ();
    $(function () {
        $("#shopName").select2();
        $("#warehouseNo").select2();
        $("#header").load("../head.html");

        App.init(); //Initialise plugins and elements
        Report.init();
        var checkButton = App.checkButton("OrderReport:Reset");
        if (checkButton) {
            $("#resetData").attr("hidden", false);
        }

    });
</script>
<!-- /JAVASCRIPTS -->
</body>

</html>